USE [vudu]
GO
/****** Object:  StoredProcedure [dbo].[ConsultaHorarioClaseMateria]    Script Date: 05/27/2011 05:38:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[ConsultaHorarioClaseMateria] 
	@seccion int

AS
BEGIN

	SET NOCOUNT ON;
		SELECT  diaSemana, Convert(char(5),horaInicio,108) as horaIni,Convert(char(5),horaFin,108) as horaFin 
		FROM HorarioClase
	    WHERE fk_SeccionMateria = @seccion
	    AND fk_SeccionPractica is NULL
    
END
